﻿CREATE PROCEDURE [acms].[UserRole_GetAllActiveByUserIdSiteId]
	@UserId int, 
	@SiteId int
AS
	SELECT *
	FROM UserRole_View
	WHERE UserId = @UserId
		and SiteId = @SiteId
		and IsNull([End], getutcdate()) >= getutcdate()
RETURN 0;